package com.fs.groupSeven.Dao;

import com.fs.groupSeven.pojo.Class;
import com.fs.groupSeven.pojo.College;
import com.fs.groupSeven.pojo.Subject;
import com.fs.groupSeven.pojo.Teacher;
import com.fs.groupSeven.pojo.User;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @description:
 * @author： mjx
 * @createDate: 2020/9/28
 * @version: 1.0
 */
public interface SubjectDao {
    List<Subject> querySubjectList(Integer collegeId);
    List<Teacher> queryTeacherList(Integer collegeId);
    Subject queryOneBySubjectId(Integer subjectId);
    int updateBySubject(Subject subject);
    int addOneBySubject(Subject subject);
    int deleteBySubject(Subject subject);
    int updateTeacherSubject(@Param("teacherId") Integer teacherId,@Param("subjectId") Integer subjectId);
    int insertTeacherSubject(@Param("teacherId") Integer teacherId,@Param("subjectId") Integer subjectId);
    List<Subject> queryByColumn(@Param("collegeId") Integer collegeId ,@Param("columnValue") String subjectName);//按课程模糊查询
    List<College> queryCollegeList();
    List<Class> queryClassList(Integer subjectId);
}
